using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class web_Controls_page_center_vtn : System.Web.UI.UserControl
{
    Common _common = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        _common = new Common();
        LoadVieclamNew();
        LoadVieclamNoibat();
    }
    void LoadVieclamNew()
    {
        rpt_vieclam_new.DataSource = _common.ExeceuteDataset("select top 8 A.ma_ho_so, A.tieu_de_ho_so, A.so_luong_tuyen, B.ten_dia_chi from ViecLamTrong_ho_so_tuyen_dung as A left join DoanhNghiep_doanh_nghiep as C on A.ma_doanh_nghiep = C.ma_doanh_nghiep left join DanhMuc_dia_chi as B on A.noi_lam_viec = B.ma_dia_chi where A.kich_hoat = 1 and C.kich_hoat = 1 order by A.ngay_dang desc");
        rpt_vieclam_new.DataBind();
    }
    void LoadVieclamNoibat()
    {
        rpt_vieclam_noibat.DataSource = _common.ExeceuteDataset("select top 8 A.ma_ho_so, A.tieu_de_ho_so, A.so_luong_tuyen, B.ten_dia_chi from ViecLamTrong_ho_so_tuyen_dung as A left join DoanhNghiep_doanh_nghiep as C on A.ma_doanh_nghiep = C.ma_doanh_nghiep left join DanhMuc_dia_chi as B on A.noi_lam_viec = B.ma_dia_chi where A.kich_hoat = 1 and C.kich_hoat = 1 and A.noi_bat = 1 order by A.ngay_dang desc");
        rpt_vieclam_noibat.DataBind();
    }
    
}
